All Questions
Tagged with ruby-on-railsmysql
8 questions
2votes
0answers
59views
MySQL Workbench RoR Migration Exporter
I created plugin for MySQL Workbench that allows you to export an ER Diagram to RoR migration files. I would like to know if any other developers appreciate it. export-rails-4-migrations_grt.py <...
1vote
2answers
85views
Fetching items from database with "Outstanding" status
I am fetching around more than 300000 items through a query: ...
5votes
3answers
4kviews
Search for User by first and/or last name, efficiently
I am refactoring a user search that just feels dirty. (Users#search) I need to allow a blank param to search on partial or only a first or last, but don't want to return all the records in the ...
- 153
1vote
1answer
204views
ActiveRecord SQL search with a filter based on parameters
For work, my colleague and I sketched this method up as a brain dump of how we want this method to work. What I am trying to figure out is how can we break this method into smaller components so that ...
- 151
1vote
1answer
203views
Review my ruby for performance
So I'm using the acts_as_taggable_on gem to tag 3 different models: Question, Blog, and Video...
1vote
1answer
424views
Allowing users to subscribe to categories
I am working on a Rails 3 application, and am having some trouble with my user/edit view. In this application, Users can subscribe to Categories. Users and Categories have a ...
- 235
2votes
3answers
521views
Extracting and mangling a parameter from a MySQL configuration file
Is there a better way of doing this? ...
- 111
8votes
1answer
861views
Avoiding sub-queries in named scopes
I use named scopes all over the place. When I have a named scope that deals with two different tables, I tend to query the second table in a sub-query. That way, if I mix and match with other tables ...
- 183
